Column | Data Type | Nullable | Default | Description |
ProductReviewID | int | not null | | Primary key for ProductReview records. |
ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID. |
ReviewerName | dbo.Name | not null | | Name of the reviewer. |
ReviewDate | datetime | not null | (getdate()) | Date review was submitted. |
EmailAddress | nvarchar(50) | not null | | Reviewer's e-mail address. |
Rating | int | not null | | Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. |
Comments | nvarchar(3850) | null | | Reviewer's comments |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |